SELECT White,ifnull(WhiteElo,'<NULL>') AS WE,ifnull(WhiteTitle,'<NULL>') AS WT FROM Games GROUP BY White,WE,WT;
Bak, Stanislaw|<NULL>|II+
Brzoza, Miroslaw|<NULL>|II
Debowski, Stanislaw|1663|II
Domagalski, Fabian|1522|II
Domaraczenko, Krzysztof|<NULL>|II
Dyrda, Konrad|<NULL>|II
Gibzinski, Stanislaw|1260|III
Grela, Franciszek|1409|II
Hutniczak, Jan|<NULL>|<NULL>
Jakubiak, Karol|<NULL>|II
Kalenik, Jan|<NULL>|III
Koltuniak, Agnieszka|<NULL>|III
Kubasik, Adam|<NULL>|IV
Kubicz, Piotr|1378|III
Kuzio, Andrzej|<NULL>|II
Mikicionek, Marek|<NULL>|IV
Paradowski, Wojciech|<NULL>|IV
Pawlowski, Slawomir|1542|II
Rembecki, Robert|1340|II
Rutowski, Tadeusz|<NULL>|III
Szadkowski, Kamil|<NULL>|III
Szczecinski, Jozef|<NULL>|II
Wiejak, Grzegorz|<NULL>|II
Wolny, Piotr|<NULL>|IV
----
SELECT Black,ifnull(BlackElo,'<NULL>') AS BE,ifnull(BlackTitle,'<NULL>') AS BT FROM Games GROUP BY Black,BE,BT;
Bak, Stanislaw|<NULL>|II+
Brzoza, Miroslaw|<NULL>|II
Debowski, Stanislaw|1663|II
Domagalski, Fabian|1522|II
Domaraczenko, Krzysztof|<NULL>|II
Dyrda, Konrad|<NULL>|II
Gibzinski, Stanislaw|1260|III
Grela, Franciszek|1409|II
Hutniczak, Jan|<NULL>|<NULL>
Jakubiak, Karol|<NULL>|II
Kalenik, Jan|<NULL>|III
Koltuniak, Agnieszka|<NULL>|III
Kubasik, Adam|<NULL>|IV
Kubicz, Piotr|1378|III
Kuzio, Andrzej|<NULL>|II
Mikicionek, Marek|<NULL>|IV
Paradowski, Wojciech|<NULL>|IV
Pawlowski, Slawomir|1542|II
Rembecki, Robert|1340|II
Rutowski, Tadeusz|<NULL>|III
Szadkowski, Kamil|<NULL>|III
Szczecinski, Jozef|<NULL>|II
Wiejak, Grzegorz|<NULL>|II
Wolny, Piotr|<NULL>|IV
----
